Skip to main content

Dataset using Simple Query

  • By this process User can create dataset by writing a simple query.
  1. Login to OPNBI training server using your credentials.

  2. Go to hamburger menu Docusaurus Slash Introduction > MasterData > Dataset Section.

    Docusaurus Slash Introduction

User can create Dataset using 2 different ways

I. From the Footer Menu

Docusaurus Slash Introduction

II. From the Context Menu

Docusaurus Slash Introduction

Note

Click here to know more about how to create Dataset.

  1. Click on Create Dataset option using anyone option listed above.

    Docusaurus Slash Introduction

  1. Enter the details in Create Dataset window as per below:-
  • Name: Demo New (user can select name as per their requirement)
  • Source: Select aws_rds from drop-down (same name as you set it when you are creating database connection)
Note

Click here to know more about Dataset Terminology.

Docusaurus Slash Introduction

  1. Write your Query in Query window as shown below:

    Docusaurus Slash Introduction

  2. For this example you can refer below Query.

Query

Select * from products

  1. We have written products in Query because we are going to use that table for making Dataset.

  2. Go to Output Columns Tab & your window will look as per image below:

    Docusaurus Slash Introduction

  1. Click on Preview button.

    Docusaurus Slash Introduction

Note

Click here to know more about Preview Tab Terminology.

  1. Click on Submit button & your Dataset will be created & it will be available in listview of Dataset section.

    Docusaurus Slash Introduction